Apple Reference & Presentation Library 1993 Spring/ARPL-Spring-93-Partner-Edition.iso/Applications/Databases/GQL V3.0 Demo/USA Sales Information/USA Sales Information.rsrc/gDEM_13258_Order Example

Text File | 1992-01-27 | 253 b | 1 lines

select customer.cust_name, customer.cust_city, customer.cust_state, orders.ord_amount from customer, orders where ((customer.cust_state = 'NY') and ((orders.ord_amount > $5000) and (orders.ord_amount < $20000))) and customer.cust_num = orders.cust_nr ;